package wtc.stu.method;

import wtc.stu.entity.StuEntity;

import java.util.List;

public class IntegratedQueryImpl implements Interface {
    @Override
    public void methodSelect() {
        System.out.println("学生信息管理系统>>>>综合查询学生信息");
        System.out.println("学生编号\t学生姓名\t年龄\t班级名称\t年级名称\t系别名称\t专业名称\t教师姓名\t备注信息");
        List<StuEntity> ar = daoIntegratedQuery.getAll();
        for (StuEntity stuEntity : ar) {
            System.out.println("" + stuEntity.getSid() + "\t" + stuEntity.getSname() + "\t" + stuEntity.getAge() + "\t" +
                    stuEntity.getCname() + "\t" + stuEntity.getGname() + "\t" + stuEntity.getXname() + "\t" + stuEntity.getZname() +
                    "\t" + stuEntity.getTname() + "\t" + stuEntity.getSremark());
        }
        System.out.println("显示完毕 ！");
    }

    public void methodSelectScore() {
        System.out.println("学生信息管理系统>>>>综合查询学生成绩信息");
        System.out.println("学生编号\t学生姓名\t班级名称\t年级名称\t系别名称\t专业名称\t成绩信息");
        List<StuEntity> ar = daoIntegratedQuery.getAllScore();
        for (StuEntity stuEntity : ar) {
            System.out.println("" + stuEntity.getSid() + "\t" + stuEntity.getSname() + "\t" + stuEntity.getCname() + "\t" +
                    stuEntity.getGname() + "\t" + stuEntity.getXname() + "\t" + stuEntity.getZname() + "\t" + stuEntity.getScore());
        }
        System.out.println("显示完毕 ！");
    }

    @Override
    public void methodInsert() {

    }

    @Override
    public void methodUpdate() {

    }

    @Override
    public void methodDelete() {

    }
}
